package vn.edu.nuce.dao;

import java.util.Date;
import java.util.List;

import vn.edu.nuce.model.LichDangKy;
import vn.edu.nuce.model.LichDangKyStatus;
import vn.edu.nuce.model.ThongKe;

public interface LichDangKyDao {

	public void addLichDangKy(LichDangKy lichDangKy);
	
	public void updateLichDangKy(LichDangKy lichDangKy);
	
	public void deleteLichDangKy(String id);
	
	public LichDangKy getLichDangKyById(String id);
	
	public List<LichDangKy> getLichDangKy();
	
	public List<LichDangKy> getLichDangKyByDate(Date date);
	
	public List<LichDangKy> getLichDangKyByDateAndUser(Date date,String userId,String status);
	
	public List<LichDangKy> getDsCho(String idPhongMay, String idTietHoc, Date date);
	
	public List<LichDangKyStatus> getLichDangKyStatusByDate(Date date);
	
	public List<LichDangKy> hienThiDangKyTrungTheoNgay(Date date);
	
	public List<LichDangKy> hienThiDangKyTrungTheoTuan(Date fromDate,Date toDate);
	
	public List<LichDangKy> getLichDangKyBy2DateAndChuaHuy(Date fromDate,Date toDate);
	
	public List<LichDangKy> getLichDangKyByDateAndChuaHuy(Date date);

	public List<LichDangKy> getLichDangKyBy2DateAndUser(Date fromDate,
			Date toDate, String userId,String status);

	public List<LichDangKy> getLichDangKyTheoMonHocAndUser(String strMonHoc,String userId,String status);
	
	public List<LichDangKy> thongKe(ThongKe thongKe);

}
